I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the SPACE() function today. The SPACE() function takes a positive integer replication count [C] as input. The function returns a string composed of a single space concatenated [C] times to itself as output. The example below adds one, two, and three spaces inside the title of a favorite movie of mine. [crayon-664ad8999e09f664310161/] [crayon-664ad8999e0a7267680554/] One thing to always worry about when using TSQL functions is how will it react with … Continue reading String Functions – SPACE()